CREATE TABLE [dbo].[JOL_SpecialityIntroduction]
(
[fdNo] [int] NOT NULL IDENTITY(1, 1),
[fdSpecID] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[fdSpecCampus] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[fdSpecIntroduction] [ntext] COLLATE Chinese_PRC_CI_AS NULL,
[fdSpecAddTime] [datetime] NULL,
[fdSpecAddID] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[fdSpecVerifyStatus] [bit] NULL CONSTRAINT [DF__JOL_Speci__fdSpe__4262CC11] DEFAULT ((0)),
[fdSpecVerifyTime] [datetime] NULL,
[fdSpecVerifyID] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[fdSpecBachelorNumber] [int] NULL CONSTRAINT [DF__JOL_Speci__fdSpe__4356F04A] DEFAULT ((0)),
[fdSpecMasterNumber] [int] NULL CONSTRAINT [DF__JOL_Speci__fdSpe__444B1483] DEFAULT ((0)),
[fdSpecDoctorNumber] [int] NULL CONSTRAINT [DF__JOL_Speci__fdSpe__453F38BC] DEFAULT ((0))
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[JOL_SpecialityIntroduction] ADD CONSTRAINT [PK__JOL_SpecialityIn__416EA7D8] PRIMARY KEY CLUSTERED  ([fdNo]) ON [PRIMARY]
GO
